StudentSubsidiaryAccountRefund 
EntityType  Independent 
Logical Entity Name  StudentSubsidiaryAccountRefund 
Default Table Name  SaSubsidiaryRefund 
Logical Only  NO 
Definition 
 
Note 
 

StudentSubsidiaryAccountRefund Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
StudentSubsidiaryAccountRefundId(PK)    INTEGER  NO 
 
StudentEnrollmentPeriodId(FK)    INTEGER  NO 
 
SubsidiaryAccountTypeId(FK)    INTEGER  NO 
 
DueDate    DATETIME  YES 
 
SentDate    DATETIME  YES 
 
Amount    MONEY(19, 4)  NO 
 
StudentRelationshipAddressId(FK)    INTEGER  YES 
 
BankAccountId(FK)    INTEGER  YES 
 
Status    CHAR(1)  NO 
 
Code    CHAR(8)  NO 
 
Description    VARCHAR(50)  NO 
 
AcademicYearSequence    SMALLINT  YES 
 
CheckNumber    VARCHAR(20)  YES 
 
Note    VARCHAR(50)  YES 
 
TermId(FK)    INTEGER  YES 
 
ReturnMethod    CHAR(1)  NO 
 
LastModifiedUserId(FK)    INTEGER  NO 
 
CreatedDateTime    DATETIME  NO 
 
LastModifiedDateTime    DATETIME  NO 
 
RowVersion    TIMESTAMP/DATE  NO 
 
PayeeName    VARCHAR(55)  YES 
 
StudentEnrollmentPeriodId(FK)    INTEGER  YES 
 

StudentSubsidiaryAccountRefund Keys 
Key Name  Key Type  Keys 
SaSubsidiaryRefund_AdTermID_N_N_IDX  Inversion Entry  TermId 
SaSubsidiaryRefund_SyAddressID_N_N_IDX  Inversion Entry  StudentRelationshipAddressId 
SaSubsidiaryRefund_UserID_N_N_IDX  Inversion Entry  LastModifiedUserId 
SaSubsidiaryRefund_SaBankAccountID_N_N_IDX  Inversion Entry  BankAccountId 
SaSubsidiaryRefund_AdEnrollID_SaSubsidiaryRefundID_U_N_IDX  Alternate Key  StudentEnrollmentPeriodId 
SaSubsidiaryRefund_SaSubsidiaryRefundID_U_C_IDX  PrimaryKey  StudentSubsidiaryAccountRefundId 
SaSubsidiaryRefund_SaSubsidiaryID_SaSubsidiaryRefundID_U_N_IDX  Alternate Key  SubsidiaryAccountTypeId, StudentEnrollmentPeriodId 

StudentSubsidiaryAccountRefund Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
BankAccount  Non-Identifying  Zero or One to Zero or More        BankAccountId  NO 
StudentEnrollmentPeriod  Non-Identifying  One To Zero or More        StudentEnrollmentPeriodId  NO 
Term  Non-Identifying  Zero or One to Zero or More        TermId  NO 
BankAccount  Non-Identifying  Zero or One to Zero or More        BankAccountId  NO 
SubsidiaryAccountType  Non-Identifying  One To Zero or More        SubsidiaryAccountTypeId  NO 
StudentRelationshipAddress  Non-Identifying  Zero or One to Zero or More        StudentRelationshipAddressId  NO 
Staff  Non-Identifying  One To Zero or More        LastModifiedUserId  NO 
StudentEnrollmentPeriod  Non-Identifying  Zero or One to Zero or More        StudentEnrollmentPeriodId  NO 
StudentRelationshipAddress  Non-Identifying  Zero or One to Zero or More        StudentRelationshipAddressId  NO 
SubsidiaryAccountType  Non-Identifying  Zero or One to Zero or More        SubsidiaryAccountTypeId  NO 
Term  Non-Identifying  Zero or One to Zero or More        TermId  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 
StudentSubsidiaryAccountTransaction  Non-Identifying  One To Zero or More          NO 
StudentAccountTransactionPendingCheck  Non-Identifying  One To Zero or More          NO 
StudentAccountTransactionPendingCheck  Non-Identifying  One To Zero or More          NO 
StudentSubsidiaryAccountTransaction  Non-Identifying  One To Zero or More          NO 

StudentSubsidiaryAccountRefund Check Constraints 
Check Constraint Name  CheckConstraint